CREATE TABLE `Admins` (
  `UserCode` VarChar(255) NOT NULL PRIMARY KEY, 
  `UserName` VarChar(255), 
  `PassWord` LongText, 
  `Remark` LongText
)
GO

CREATE TABLE `Functions` (
  `FuncID` Long NOT NULL IDENTITY(1,1) PRIMARY KEY, 
  `FuncName` VarChar(255), 
  `FuncType` VarChar(100), 
  `CodeType` VarChar(255), 
  `CreateTime` DateTime, 
  `CreatorMail` VarChar(255), 
  `Code` LongText, 
  `Likes` Long, 
  `LastLikeIP` VarChar(250)
)
GO

CREATE TABLE `Languages` (
  `LanID` Long NOT NULL IDENTITY(1,1) PRIMARY KEY, 
  `LanName` VarChar(255)
)
GO

CREATE TABLE `ShareMovie` (
  `id` Long NOT NULL IDENTITY(1,1) PRIMARY KEY, 
  `en_name` LongText, 
  `cn_name` LongText, 
  `created_at` DateTime, 
  `comments` LongText, 
  `grade` Currency, 
  `type_name` LongText, 
  `area_name` VarChar(50), 
  `contact` LongText
)
GO

CREATE TABLE `VisitLog` (
  `visit_at` DateTime, 
  `visit_page` LongText, 
  `visit_from` LongText, 
  `visit_ip` LongText, 
  `id` Long NOT NULL IDENTITY(1,1) PRIMARY KEY, 
  `role` VarChar(50), 
  `post_params` LongText, 
  `get_params` LongText
)
GO